﻿using BellAssistant.Model.Enum;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BellAssistant.Model.Tables
{
    public class Goods:CDataContext.CEntity
    {
        /// <summary>
        /// 商品ID
        /// </summary>
        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = false, Att_ISPrimary = true, Att_AutoIncrement = true)]
        public int GoodsID { get; set; }

        /// <summary>
        /// 商品类别
        /// </summary>
       
        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
       
        public int ProductCategoryID { get; set; }

        /// <summary>
        /// 商品名称
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public string Name { get; set; }

        /// <summary>
        /// 商品品牌
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public int BrandID { get; set; }

        /// <summary>
        /// 商品来源
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public string Source { get; set; }

        /// <summary>
        /// 促销类型
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public int PromotionID { get; set; }

        /// <summary>
        /// 快递类型
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public int ExpressTypeID { get; set; }

        /// <summary>
        /// 成本
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public double Cost { get; set; }

        /// <summary>
        /// 售价
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public double Price { get; set; }

        /// <summary>
        /// 促销价
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public double PromotionPrice { get; set; }

        /// <summary>
        /// 利润
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public double Profit { get; set; }

        /// <summary>
        /// 状态
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public bool Status { get; set; }

        /// <summary>
        /// 状态含义
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public string StatusMean { get; set; }

        /// <summary>
        /// 发货地
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public string ConsignmentPlace { get; set; }

        /// <summary>
        /// 促销日起
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public DateTime PromotionStart { get; set; }

        /// <summary>
        /// 促销日止
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public DateTime PromotionEnd { get; set; }

        /// <summary>
        /// 上架日期
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public DateTime Shelves { get; set; }

        /// <summary>
        /// 下架日期
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public DateTime OffShelves { get; set; }


        /// <summary>
        /// 总销量
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public int SalesAmount { get; set; }

        /// <summary>
        /// 总利润
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public double GrossProfit { get; set; }

        /// <summary>
        /// 库存
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public int Stock { get; set; }

        /// <summary>
        /// 商品URL地址
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public string URL { get; set; }

        /// <summary>
        /// 快递公司
        /// </summary>

        [CDataContext.CAttribute.DataColumnAttirbute(Att_AlowNULL = true)]
        public string ExpressChipper { get; set; }
    }
}
